﻿--HEADER Make columns in series nullable

ALTER TABLE Analytics.InvestmentSecuritySerie ALTER COLUMN [MarketCapSum] decimal(29,0) NULL
GO
ALTER TABLE Analytics.InvestmentSecuritySerie ALTER COLUMN [CloseExposure] money NULL
GO
ALTER TABLE Analytics.InvestmentSecuritySerie ALTER COLUMN [PositionPnL] decimal(18,4) NULL
GO
ALTER TABLE Analytics.InvestmentSecuritySerie ALTER COLUMN [PositionFxPnL] decimal(18,4) NULL
GO
ALTER TABLE Analytics.InvestmentSecuritySerie ALTER COLUMN [TradePnL] decimal(18,4) NULL
GO
ALTER TABLE Analytics.InvestmentSecuritySerie ALTER COLUMN [TradeFxPnL] decimal(18,4) NULL
GO

ALTER TABLE Analytics.InvestmentSerie ALTER COLUMN [MarketCapSum] decimal(29,0) NULL